Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	584524
Missing cells	137396
Missing cells (%)	1.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	93.7 MiB
Average record size in memory	168.0 B

Variable types

Numeric	7
Categorical	7
DateTime	3
Text	3
Unsupported	1

Alerts

`item_id` is highly overall correlated with `Customer ID` and 3 other fields	High correlation
`price` is highly overall correlated with `grand_total`	High correlation
`grand_total` is highly overall correlated with `price`	High correlation
`Month` is highly overall correlated with `M-Y`	High correlation
`Customer ID` is highly overall correlated with `item_id` and 3 other fields	High correlation
`status` is highly overall correlated with `BI Status`	High correlation
`BI Status` is highly overall correlated with `status`	High correlation
`Year` is highly overall correlated with `item_id` and 3 other fields	High correlation
`M-Y` is highly overall correlated with `item_id` and 4 other fields	High correlation
`FY` is highly overall correlated with `item_id` and 3 other fields	High correlation
`status` is highly imbalanced (51.7%)	Imbalance
`sales_commission_code` has 137175 (23.5%) missing values	Missing
`qty_ordered` is highly skewed (γ1 = 184.7792386)	Skewed
`grand_total` is highly skewed (γ1 = 254.9982139)	Skewed
`item_id` has unique values	Unique
`increment_id` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`grand_total` has 9632 (1.6%) zeros	Zeros
`discount_amount` has 376306 (64.4%) zeros	Zeros

Reproduction

Analysis started	2023-09-13 12:50:52.871403
Analysis finished	2023-09-13 12:52:51.750405
Duration	1 minute and 58.88 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

item_id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	584524
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	565667.07

Minimum	211131
Maximum	905208
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	211131
5-th percentile	247522.15
Q1	395000.75
median	568424.5
Q3	739106.25
95-th percentile	872504.85
Maximum	905208
Range	694077
Interquartile range (IQR)	344105.5

Descriptive statistics

Standard deviation	200121.17
Coefficient of variation (CV)	0.35377907
Kurtosis	-1.1845506
Mean	565667.07
Median Absolute Deviation (MAD)	171889
Skewness	-0.047515772
Sum	3.3064598 × 10¹¹
Variance	4.0048484 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
211131	1	< 0.1%
683031	1	< 0.1%
683022	1	< 0.1%
683023	1	< 0.1%
683030	1	< 0.1%
683029	1	< 0.1%
683033	1	< 0.1%
683032	1	< 0.1%
683035	1	< 0.1%
683026	1	< 0.1%
Other values (584514)	584514	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
211131	1	< 0.1%
211133	1	< 0.1%
211134	1	< 0.1%
211135	1	< 0.1%
211136	1	< 0.1%
211137	1	< 0.1%
211138	1	< 0.1%
211139	1	< 0.1%
211140	1	< 0.1%
211141	1	< 0.1%

Value	Count	Frequency (%)
905208	1	< 0.1%
905207	1	< 0.1%
905206	1	< 0.1%
905205	1	< 0.1%
905204	1	< 0.1%
905202	1	< 0.1%
905200	1	< 0.1%
905199	1	< 0.1%
905198	1	< 0.1%
905196	1	< 0.1%

status
Categorical

HIGH CORRELATION IMBALANCE

Distinct	16
Distinct (%)	< 0.1%
Missing	15
Missing (%)	< 0.1%
Memory size	4.5 MiB

complete	233685
canceled	201249
received	77290
order_refunded	59529
refund	8050
Other values (11)	4706

Length

Max length	14
Median length	8
Mean length	8.5499334
Min length	2

Characters and Unicode

Total characters	4997513
Distinct characters	24
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	complete
2nd row	canceled
3rd row	canceled
4th row	complete
5th row	order_refunded

Common Values

Value	Count	Frequency (%)
complete	233685	40.0%
canceled	201249	34.4%
received	77290	13.2%
order_refunded	59529	10.2%
refund	8050	1.4%
cod	2859	0.5%
paid	1159	0.2%
closed	494	0.1%
payment_review	57	< 0.1%
pending	48	< 0.1%
Other values (6)	89	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
complete	233685	40.0%
canceled	201249	34.4%
received	77290	13.2%
order_refunded	59529	10.2%
refund	8050	1.4%
cod	2859	0.5%
paid	1159	0.2%
closed	494	0.1%
payment_review	57	< 0.1%
pending	48	< 0.1%
Other values (6)	89	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	1289167	25.8%
c	716863	14.3%
d	469815	9.4%
l	435466	8.7%
o	296631	5.9%
n	269032	5.4%
r	264027	5.3%
p	235003	4.7%
m	233742	4.7%
t	233742	4.7%
Other values (14)	554025	11.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4937912	98.8%
Connector Punctuation	59593	1.2%
Other Punctuation	4	< 0.1%
Uppercase Letter	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1289167	26.1%
c	716863	14.5%
d	469815	9.5%
l	435466	8.8%
o	296631	6.0%
n	269032	5.4%
r	264027	5.3%
p	235003	4.8%
m	233742	4.7%
t	233742	4.7%
Other values (11)	494424	10.0%

Connector Punctuation

Value	Count	Frequency (%)
_	59593	100.0%

Other Punctuation

Value	Count	Frequency (%)
\	4	100.0%

Uppercase Letter

Value	Count	Frequency (%)
N	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4937916	98.8%
Common	59597	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1289167	26.1%
c	716863	14.5%
d	469815	9.5%
l	435466	8.8%
o	296631	6.0%
n	269032	5.4%
r	264027	5.3%
p	235003	4.8%
m	233742	4.7%
t	233742	4.7%
Other values (12)	494428	10.0%

Common

Value	Count	Frequency (%)
_	59593	> 99.9%
\	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4997513	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1289167	25.8%
c	716863	14.3%
d	469815	9.4%
l	435466	8.7%
o	296631	5.9%
n	269032	5.4%
r	264027	5.3%
p	235003	4.7%
m	233742	4.7%
t	233742	4.7%
Other values (14)	554025	11.1%

created_at
Date

Distinct	789
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

Minimum	2016-07-01 00:00:00
Maximum	2018-08-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

sku
Text

Distinct	84889
Distinct (%)	14.5%
Missing	20
Missing (%)	< 0.1%
Memory size	4.5 MiB

Length

Max length	69
Median length	63
Mean length	20.254032
Min length	5

Characters and Unicode

Total characters	11838563
Distinct characters	94
Distinct categories	13 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	38653 ?
Unique (%)	6.6%

Sample

1st row	kreations_YI 06-L
2nd row	kcc_Buy 2 Frey Air Freshener & Get 1 Kasual Body Spray Free
3rd row	Ego_UP0017-999-MR0
4th row	kcc_krone deal
5th row	BK7010400AG

Value	Count	Frequency (%)
	17805	1.9%
infinix	5978	0.7%
halwa	5418	0.6%
hot	4859	0.5%
black	4616	0.5%
one	4385	0.5%
of	4104	0.4%
matsam59db75adb2f80	3775	0.4%
sohan	3718	0.4%
al	3661	0.4%
Other values (86322)	856654	93.6%

Most occurring characters

Value	Count	Frequency (%)
A	765823	6.5%
5	536900	4.5%
0	464376	3.9%
B	424348	3.6%
-	366768	3.1%
e	348343	2.9%
9	348133	2.9%
1	345339	2.9%
a	344867	2.9%
E	340693	2.9%
Other values (84)	7552973	63.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4517562	38.2%
Decimal Number	3268014	27.6%
Lowercase Letter	3026250	25.6%
Dash Punctuation	366787	3.1%
Space Separator	336856	2.8%
Connector Punctuation	297722	2.5%
Other Punctuation	14679	0.1%
Open Punctuation	4520	< 0.1%
Close Punctuation	4506	< 0.1%
Math Symbol	1525	< 0.1%
Other values (3)	142	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	348343	11.5%
a	344867	11.4%
i	247921	8.2%
o	208073	6.9%
l	201562	6.7%
r	200692	6.6%
n	195456	6.5%
t	166925	5.5%
s	143911	4.8%
c	121305	4.0%
Other values (18)	847195	28.0%

Uppercase Letter

Value	Count	Frequency (%)
A	765823	17.0%
B	424348	9.4%
E	340693	7.5%
C	327481	7.2%
F	323007	7.2%
D	288921	6.4%
M	276654	6.1%
S	231839	5.1%
T	191365	4.2%
P	175903	3.9%
Other values (17)	1171528	25.9%

Decimal Number

Value	Count	Frequency (%)
5	536900	16.4%
0	464376	14.2%
9	348133	10.7%
1	345339	10.6%
2	281248	8.6%
3	274352	8.4%
7	271984	8.3%
4	262229	8.0%
6	242830	7.4%
8	240623	7.4%

Other Punctuation

Value	Count	Frequency (%)
&	5968	40.7%
.	3473	23.7%
/	1987	13.5%
'	1174	8.0%
,	922	6.3%
#	392	2.7%
"	280	1.9%
:	251	1.7%
%	231	1.6%
\	1	< 0.1%

Math Symbol

Value	Count	Frequency (%)
+	1502	98.5%
\|	12	0.8%
=	9	0.6%
×	2	0.1%

Control

Value	Count	Frequency (%)
	12	80.0%
	2	13.3%
	1	6.7%

Dash Punctuation

Value	Count	Frequency (%)
-	366768	> 99.9%
–	19	< 0.1%

Space Separator

Value	Count	Frequency (%)
	336313	99.8%
	543	0.2%

Open Punctuation

Value	Count	Frequency (%)
(	4495	99.4%
[	25	0.6%

Close Punctuation

Value	Count	Frequency (%)
)	4481	99.4%
]	25	0.6%

Other Symbol

Value	Count	Frequency (%)
°	3	75.0%
®	1	25.0%

Connector Punctuation

Value	Count	Frequency (%)
_	297722	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	123	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7543812	63.7%
Common	4294751	36.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	765823	10.2%
B	424348	5.6%
e	348343	4.6%
a	344867	4.6%
E	340693	4.5%
C	327481	4.3%
F	323007	4.3%
D	288921	3.8%
M	276654	3.7%
i	247921	3.3%
Other values (45)	3855754	51.1%

Common

Value	Count	Frequency (%)
5	536900	12.5%
0	464376	10.8%
-	366768	8.5%
9	348133	8.1%
1	345339	8.0%
	336313	7.8%
_	297722	6.9%
2	281248	6.5%
3	274352	6.4%
7	271984	6.3%
Other values (29)	771616	18.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11837950	> 99.9%
None	594	< 0.1%
Punctuation	19	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	765823	6.5%
5	536900	4.5%
0	464376	3.9%
B	424348	3.6%
-	366768	3.1%
e	348343	2.9%
9	348133	2.9%
1	345339	2.9%
a	344867	2.9%
E	340693	2.9%
Other values (76)	7552360	63.8%

None

Value	Count	Frequency (%)
	543	91.4%
è	20	3.4%
È	13	2.2%
é	12	2.0%
°	3	0.5%
×	2	0.3%
®	1	0.2%

Punctuation

Value	Count	Frequency (%)
–	19	100.0%

price
Real number (ℝ)

HIGH CORRELATION

Distinct	9121
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6348.7475

Minimum	0
Maximum	1012625.9
Zeros	2232
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	0
5-th percentile	95
Q1	360
median	899
Q3	4070
95-th percentile	29199
Maximum	1012625.9
Range	1012625.9
Interquartile range (IQR)	3710

Descriptive statistics

Standard deviation	14949.27
Coefficient of variation (CV)	2.3546801
Kurtosis	71.248367
Mean	6348.7475
Median Absolute Deviation (MAD)	699
Skewness	5.228716
Sum	3.7109953 × 10⁹
Variance	2.2348066 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000	11077	1.9%
999	10120	1.7%
500	9215	1.6%
699	8407	1.4%
499	7693	1.3%
399	6999	1.2%
299	6647	1.1%
799	6024	1.0%
599	6008	1.0%
899	4471	0.8%
Other values (9111)	507863	86.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2232	0.4%
0.1	15	< 0.1%
0.11	8	< 0.1%
0.15	1	< 0.1%
0.2	16	< 0.1%
0.8	9	< 0.1%
1	1237	0.2%
1.3	24	< 0.1%
1.5	20	< 0.1%
1.6	34	< 0.1%

Value	Count	Frequency (%)
1012625.9	1	< 0.1%
515975	1	< 0.1%
479000	4	< 0.1%
330499	2	< 0.1%
320000	1	< 0.1%
307970	2	< 0.1%
300000	4	< 0.1%
291667	2	< 0.1%
289999	1	< 0.1%
265499	1	< 0.1%

qty_ordered
Real number (ℝ)

SKEWED

Distinct	74
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2963882

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	3
Maximum	1000
Range	999
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.9960611
Coefficient of variation (CV)	3.0824572
Kurtosis	42587.952
Mean	1.2963882
Median Absolute Deviation (MAD)	0
Skewness	184.77924
Sum	757770
Variance	15.968504
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	505214	86.4%
2	46656	8.0%
3	15406	2.6%
5	11213	1.9%
4	4141	0.7%
6	589	0.1%
10	292	< 0.1%
8	153	< 0.1%
7	112	< 0.1%
12	95	< 0.1%
Other values (64)	653	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	505214	86.4%
2	46656	8.0%
3	15406	2.6%
4	4141	0.7%
5	11213	1.9%
6	589	0.1%
7	112	< 0.1%
8	153	< 0.1%
9	42	< 0.1%
10	292	< 0.1%

Value	Count	Frequency (%)
1000	6	< 0.1%
502	1	< 0.1%
500	4	< 0.1%
380	1	< 0.1%
304	1	< 0.1%
300	2	< 0.1%
200	7	< 0.1%
187	1	< 0.1%
186	1	< 0.1%
185	1	< 0.1%

grand_total
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	36829
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8530.6186

Minimum	-1594
Maximum	17888000
Zeros	9632
Zeros (%)	1.6%
Negative	76
Negative (%)	< 0.1%
Memory size	4.5 MiB

Quantile statistics

Minimum	-1594
5-th percentile	160
Q1	945
median	1960.4
Q3	6999
95-th percentile	34497.65
Maximum	17888000
Range	17889594
Interquartile range (IQR)	6054

Descriptive statistics

Standard deviation	61320.815
Coefficient of variation (CV)	7.1883198
Kurtosis	74191.656
Mean	8530.6186
Median Absolute Deviation (MAD)	1461.4
Skewness	254.99821
Sum	4.9863513 × 10⁹
Variance	3.7602423 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9632	1.6%
1000	5146	0.9%
2000	3781	0.6%
2500	3235	0.6%
5000	2912	0.5%
1149	2525	0.4%
12599	2520	0.4%
399	2459	0.4%
4000	2387	0.4%
150	2256	0.4%
Other values (36819)	547671	93.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1594	1	< 0.1%
-1311.5	7	< 0.1%
-1106.65	1	< 0.1%
-873.4	1	< 0.1%
-528	1	< 0.1%
-511	2	< 0.1%
-425.7	2	< 0.1%
-384	1	< 0.1%
-340.6	16	< 0.1%
-249	1	< 0.1%

Value	Count	Frequency (%)
17888000	6	< 0.1%
1315875	1	< 0.1%
1280473	2	< 0.1%
1279980	1	< 0.1%
1155966	1	< 0.1%
1039479	1	< 0.1%
1028751	4	< 0.1%
1012625.9	1	< 0.1%
888065	7	< 0.1%
847024	7	< 0.1%

increment_id
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

category_name_1
Categorical

Distinct	16
Distinct (%)	< 0.1%
Missing	164
Missing (%)	< 0.1%
Memory size	4.5 MiB

Mobiles & Tablets	115710
Men's Fashion	92221
Women's Fashion	59721
Appliances	52413
Superstore	43613
Other values (11)	220682

Length

Max length	18
Median length	17
Mean length	12.839072
Min length	2

Characters and Unicode

Total characters	7502640
Distinct characters	39
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Women's Fashion
2nd row	Beauty & Grooming
3rd row	Women's Fashion
4th row	Beauty & Grooming
5th row	Soghaat

Common Values

Value	Count	Frequency (%)
Mobiles & Tablets	115710	19.8%
Men's Fashion	92221	15.8%
Women's Fashion	59721	10.2%
Appliances	52413	9.0%
Superstore	43613	7.5%
Beauty & Grooming	41496	7.1%
Soghaat	34011	5.8%
Others	29218	5.0%
Home & Living	26504	4.5%
Entertainment	26326	4.5%
Other values (6)	63127	10.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	221184	18.8%
fashion	151942	12.9%
mobiles	115710	9.8%
tablets	115710	9.8%
men's	92221	7.8%
women's	59721	5.1%
appliances	52413	4.4%
superstore	43613	3.7%
beauty	41496	3.5%
grooming	41496	3.5%
Other values (14)	243164	20.6%

Most occurring characters

Value	Count	Frequency (%)
s	696414	9.3%
e	690373	9.2%
	594310	7.9%
o	562102	7.5%
n	522686	7.0%
a	493383	6.6%
i	476800	6.4%
t	397441	5.3%
l	304813	4.1%
b	247914	3.3%
Other values (29)	2516404	33.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5569868	74.2%
Uppercase Letter	957486	12.8%
Space Separator	594310	7.9%
Other Punctuation	380976	5.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	696414	12.5%
e	690373	12.4%
o	562102	10.1%
n	522686	9.4%
a	493383	8.9%
i	476800	8.6%
t	397441	7.1%
l	304813	5.5%
b	247914	4.5%
h	236151	4.2%
Other values (10)	941791	16.9%

Uppercase Letter

Value	Count	Frequency (%)
M	207931	21.7%
F	151942	15.9%
T	115710	12.1%
S	98604	10.3%
B	59860	6.3%
W	59721	6.2%
A	52413	5.5%
H	44006	4.6%
G	41496	4.3%
E	29804	3.1%
Other values (5)	95999	10.0%

Other Punctuation

Value	Count	Frequency (%)
&	221184	58.1%
'	151942	39.9%
\	7850	2.1%

Space Separator

Value	Count	Frequency (%)
	594310	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6527354	87.0%
Common	975286	13.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	696414	10.7%
e	690373	10.6%
o	562102	8.6%
n	522686	8.0%
a	493383	7.6%
i	476800	7.3%
t	397441	6.1%
l	304813	4.7%
b	247914	3.8%
h	236151	3.6%
Other values (25)	1899277	29.1%

Common

Value	Count	Frequency (%)
	594310	60.9%
&	221184	22.7%
'	151942	15.6%
\	7850	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7502640	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	696414	9.3%
e	690373	9.2%
	594310	7.9%
o	562102	7.5%
n	522686	7.0%
a	493383	6.6%
i	476800	6.4%
t	397441	5.3%
l	304813	4.1%
b	247914	3.3%
Other values (29)	2516404	33.5%

sales_commission_code
Text

MISSING

Distinct	7225
Distinct (%)	1.6%
Missing	137175
Missing (%)	23.5%
Memory size	4.5 MiB

Length

Max length	100
Median length	2
Mean length	4.0094088
Min length	1

Characters and Unicode

Total characters	1793605
Distinct characters	88
Distinct categories	14 ?
Distinct scripts	3 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3126 ?
Unique (%)	0.7%

Sample

1st row	\N
2nd row	\N
3rd row	\N
4th row	R-FSD-52352
5th row	\N

Value	Count	Frequency (%)
n	339002	73.3%
c	4272	0.9%
skz	2807	0.6%
40968	2711	0.6%
c-lhc-30667	2654	0.6%
c-lhw-50074	2436	0.5%
r	2366	0.5%
cisb30211	2334	0.5%
c-rwp-31924	1938	0.4%
cmux33202	1883	0.4%
Other values (6333)	100087	21.6%

Most occurring characters

Value	Count	Frequency (%)
N	339256	18.9%
\	339001	18.9%
-	147598	8.2%
1	93561	5.2%
0	92891	5.2%
4	79416	4.4%
3	57271	3.2%
C	54301	3.0%
2	47864	2.7%
6	45449	2.5%
Other values (78)	496997	27.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	663978	37.0%
Decimal Number	564880	31.5%
Other Punctuation	339781	18.9%
Dash Punctuation	147598	8.2%
Lowercase Letter	58671	3.3%
Space Separator	15594	0.9%
Connector Punctuation	3070	0.2%
Math Symbol	22	< 0.1%
Format	4	< 0.1%
Open Punctuation	2	< 0.1%
Other values (4)	5	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	339256	51.1%
C	54301	8.2%
R	41488	6.2%
H	29441	4.4%
U	21270	3.2%
S	20710	3.1%
W	19366	2.9%
D	17800	2.7%
M	15053	2.3%
X	14595	2.2%
Other values (17)	90698	13.7%

Lowercase Letter

Value	Count	Frequency (%)
c	10452	17.8%
s	6115	10.4%
u	5500	9.4%
i	3486	5.9%
d	3392	5.8%
b	3268	5.6%
h	3158	5.4%
f	2890	4.9%
x	2636	4.5%
m	2610	4.4%
Other values (17)	15164	25.8%

Other Punctuation

Value	Count	Frequency (%)
\	339001	99.8%
/	434	0.1%
.	296	0.1%
#	10	< 0.1%
,	8	< 0.1%
@	7	< 0.1%
:	4	< 0.1%
?	4	< 0.1%
!	4	< 0.1%
"	4	< 0.1%
Other values (3)	9	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	93561	16.6%
0	92891	16.4%
4	79416	14.1%
3	57271	10.1%
2	47864	8.5%
6	45449	8.0%
5	44564	7.9%
9	37008	6.6%
8	34037	6.0%
7	32819	5.8%

Math Symbol

Value	Count	Frequency (%)
+	20	90.9%
=	2	9.1%

Dash Punctuation

Value	Count	Frequency (%)
-	147598	100.0%

Space Separator

Value	Count	Frequency (%)
	15594	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	3070	100.0%

Format

Value	Count	Frequency (%)
	4	100.0%

Open Punctuation

Value	Count	Frequency (%)
[	2	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	2	100.0%

Control

Value	Count	Frequency (%)
	1	100.0%

Other Symbol

Value	Count	Frequency (%)
✖	1	100.0%

Nonspacing Mark

Value	Count	Frequency (%)
️	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1070955	59.7%
Latin	722649	40.3%
Inherited	1	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	339256	46.9%
C	54301	7.5%
R	41488	5.7%
H	29441	4.1%
U	21270	2.9%
S	20710	2.9%
W	19366	2.7%
D	17800	2.5%
M	15053	2.1%
X	14595	2.0%
Other values (44)	149369	20.7%

Common

Value	Count	Frequency (%)
\	339001	31.7%
-	147598	13.8%
1	93561	8.7%
0	92891	8.7%
4	79416	7.4%
3	57271	5.3%
2	47864	4.5%
6	45449	4.2%
5	44564	4.2%
9	37008	3.5%
Other values (23)	86332	8.1%

Inherited

Value	Count	Frequency (%)
️	1	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1793596	> 99.9%
None	7	< 0.1%
Dingbats	1	< 0.1%
VS	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	339256	18.9%
\	339001	18.9%
-	147598	8.2%
1	93561	5.2%
0	92891	5.2%
4	79416	4.4%
3	57271	3.2%
C	54301	3.0%
2	47864	2.7%
6	45449	2.5%
Other values (73)	496988	27.7%

None

Value	Count	Frequency (%)
	4	57.1%
Ç	2	28.6%
ß	1	14.3%

Dingbats

Value	Count	Frequency (%)
✖	1	100.0%

VS

Value	Count	Frequency (%)
️	1	100.0%

discount_amount
Real number (ℝ)

ZEROS

Distinct	28058
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	499.49278

Minimum	-599.5
Maximum	90300
Zeros	376306
Zeros (%)	64.4%
Negative	3
Negative (%)	< 0.1%
Memory size	4.5 MiB

Quantile statistics

Minimum	-599.5
5-th percentile	0
Q1	0
median	0
Q3	160.5
95-th percentile	2930
Maximum	90300
Range	90899.5
Interquartile range (IQR)	160.5

Descriptive statistics

Standard deviation	1506.943
Coefficient of variation (CV)	3.0169466
Kurtosis	117.5672
Mean	499.49278
Median Absolute Deviation (MAD)	0
Skewness	6.8424543
Sum	2.9196551 × 10⁸
Variance	2270877.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	376306	64.4%
1000	5426	0.9%
2000	4143	0.7%
500	3648	0.6%
200	3496	0.6%
3000	2361	0.4%
7000	2289	0.4%
1500	1625	0.3%
4000	1429	0.2%
2200	1409	0.2%
Other values (28048)	182392	31.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-599.5	1	< 0.1%
-2	2	< 0.1%
0	376306	64.4%
0.08	1	< 0.1%
0.1	6	< 0.1%
0.14	1	< 0.1%
0.15	36	< 0.1%
0.16	1	< 0.1%
0.19	1	< 0.1%
0.2	12	< 0.1%

Value	Count	Frequency (%)
90300	2	< 0.1%
50355.25	5	< 0.1%
50127.75	5	< 0.1%
48205	1	< 0.1%
47500	4	< 0.1%
45000	1	< 0.1%
42498.75	1	< 0.1%
41885	1	< 0.1%
38075.07	8	< 0.1%
35609.39	1	< 0.1%

payment_method
Categorical

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

cod	271960
Payaxis	97641
Easypay	82900
jazzwallet	35145
easypay_voucher	31176
Other values (13)	65702

Length

Max length	17
Median length	16
Mean length	6.1900538
Min length	3

Characters and Unicode

Total characters	3618235
Distinct characters	30
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	cod
2nd row	cod
3rd row	cod
4th row	cod
5th row	cod

Common Values

Value	Count	Frequency (%)
cod	271960	46.5%
Payaxis	97641	16.7%
Easypay	82900	14.2%
jazzwallet	35145	6.0%
easypay_voucher	31176	5.3%
bankalfalah	23065	3.9%
jazzvoucher	15633	2.7%
Easypay_MA	14028	2.4%
customercredit	7555	1.3%
apg	1758	0.3%
Other values (8)	3663	0.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cod	271960	46.5%
payaxis	97641	16.7%
easypay	82900	14.2%
jazzwallet	35145	6.0%
easypay_voucher	31176	5.3%
bankalfalah	23065	3.9%
jazzvoucher	15633	2.7%
easypay_ma	14028	2.4%
customercredit	7555	1.3%
apg	1758	0.3%
Other values (8)	3663	0.6%

Most occurring characters

Value	Count	Frequency (%)
a	635647	17.6%
y	355187	9.8%
c	337363	9.3%
o	327913	9.1%
d	282261	7.8%
s	234824	6.5%
e	132555	3.7%
p	130764	3.6%
l	118040	3.3%
i	107930	3.0%
Other values (20)	955751	26.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3350406	92.6%
Uppercase Letter	222625	6.2%
Connector Punctuation	45204	1.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	635647	19.0%
y	355187	10.6%
c	337363	10.1%
o	327913	9.8%
d	282261	8.4%
s	234824	7.0%
e	132555	4.0%
p	130764	3.9%
l	118040	3.5%
i	107930	3.2%
Other values (15)	687922	20.5%

Uppercase Letter

Value	Count	Frequency (%)
P	97641	43.9%
E	96928	43.5%
M	14028	6.3%
A	14028	6.3%

Connector Punctuation

Value	Count	Frequency (%)
_	45204	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3573031	98.8%
Common	45204	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	635647	17.8%
y	355187	9.9%
c	337363	9.4%
o	327913	9.2%
d	282261	7.9%
s	234824	6.6%
e	132555	3.7%
p	130764	3.7%
l	118040	3.3%
i	107930	3.0%
Other values (19)	910547	25.5%

Common

Value	Count	Frequency (%)
_	45204	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3618235	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	635647	17.6%
y	355187	9.8%
c	337363	9.3%
o	327913	9.1%
d	282261	7.8%
s	234824	6.5%
e	132555	3.7%
p	130764	3.6%
l	118040	3.3%
i	107930	3.0%
Other values (20)	955751	26.4%

Working Date
Date

Distinct	789
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

Minimum	2016-07-01 00:00:00
Maximum	2018-08-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

BI Status
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

Net	234178
Gross	201454
Valid	148891
#REF!	1

Length

Max length	5
Median length	5
Mean length	4.1987395
Min length	3

Characters and Unicode

Total characters	2454264
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	#REF!
2nd row	Gross
3rd row	Gross
4th row	Net
5th row	Valid

Common Values

Value	Count	Frequency (%)
Net	234178	40.1%
Gross	201454	34.5%
Valid	148891	25.5%
#REF!	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
net	234178	40.1%
gross	201454	34.5%
valid	148891	25.5%
ref	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
s	402908	16.4%
N	234178	9.5%
t	234178	9.5%
e	234178	9.5%
G	201454	8.2%
r	201454	8.2%
o	201454	8.2%
i	148891	6.1%
d	148891	6.1%
a	148891	6.1%
Other values (7)	297787	12.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1869736	76.2%
Uppercase Letter	584526	23.8%
Other Punctuation	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	402908	21.5%
t	234178	12.5%
e	234178	12.5%
r	201454	10.8%
o	201454	10.8%
i	148891	8.0%
d	148891	8.0%
a	148891	8.0%
l	148891	8.0%

Uppercase Letter

Value	Count	Frequency (%)
N	234178	40.1%
G	201454	34.5%
V	148891	25.5%
R	1	< 0.1%
E	1	< 0.1%
F	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
#	1	50.0%
!	1	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2454262	> 99.9%
Common	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	402908	16.4%
N	234178	9.5%
t	234178	9.5%
e	234178	9.5%
G	201454	8.2%
r	201454	8.2%
o	201454	8.2%
i	148891	6.1%
d	148891	6.1%
a	148891	6.1%
Other values (5)	297785	12.1%

Common

Value	Count	Frequency (%)
#	1	50.0%
!	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2454264	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	402908	16.4%
N	234178	9.5%
t	234178	9.5%
e	234178	9.5%
G	201454	8.2%
r	201454	8.2%
o	201454	8.2%
i	148891	6.1%
d	148891	6.1%
a	148891	6.1%
Other values (7)	297787	12.1%

MV
Text

Distinct	9720
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

Length

Max length	9
Median length	7
Mean length	4.1444731
Min length	1

Characters and Unicode

Total characters	2422544
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2233 ?
Unique (%)	0.4%

Sample

1st row	1,950
2nd row	240
3rd row	2,450
4th row	360
5th row	1,110

Value	Count	Frequency (%)
999	9516	1.6%
699	7801	1.3%
499	7157	1.2%
1,000	6895	1.2%
399	6506	1.1%
299	5997	1.0%
599	5721	1.0%
799	5715	1.0%
2,000	4499	0.8%
899	4353	0.7%
Other values (9710)	520364	89.0%

Most occurring characters

Value	Count	Frequency (%)
0	414466	17.1%
9	399121	16.5%
,	289367	11.9%
1	247310	10.2%
5	220128	9.1%
2	188243	7.8%
4	151901	6.3%
3	146616	6.1%
8	128646	5.3%
6	117186	4.8%
Other values (3)	119560	4.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2122017	87.6%
Other Punctuation	289367	11.9%
Space Separator	8928	0.4%
Dash Punctuation	2232	0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	414466	19.5%
9	399121	18.8%
1	247310	11.7%
5	220128	10.4%
2	188243	8.9%
4	151901	7.2%
3	146616	6.9%
8	128646	6.1%
6	117186	5.5%
7	108400	5.1%

Other Punctuation

Value	Count	Frequency (%)
,	289367	100.0%

Space Separator

Value	Count	Frequency (%)
	8928	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2232	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2422544	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	414466	17.1%
9	399121	16.5%
,	289367	11.9%
1	247310	10.2%
5	220128	9.1%
2	188243	7.8%
4	151901	6.3%
3	146616	6.1%
8	128646	5.3%
6	117186	4.8%
Other values (3)	119560	4.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2422544	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	414466	17.1%
9	399121	16.5%
,	289367	11.9%
1	247310	10.2%
5	220128	9.1%
2	188243	7.8%
4	151901	6.3%
3	146616	6.1%
8	128646	5.3%
6	117186	4.8%
Other values (3)	119560	4.9%

Year
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

2017	290920
2018	159695
2016	133909

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	2338096
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2016
2nd row	2016
3rd row	2016
4th row	2016
5th row	2016

Common Values

Value	Count	Frequency (%)
2017	290920	49.8%
2018	159695	27.3%
2016	133909	22.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2017	290920	49.8%
2018	159695	27.3%
2016	133909	22.9%

Most occurring characters

Value	Count	Frequency (%)
2	584524	25.0%
0	584524	25.0%
1	584524	25.0%
7	290920	12.4%
8	159695	6.8%
6	133909	5.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2338096	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	584524	25.0%
0	584524	25.0%
1	584524	25.0%
7	290920	12.4%
8	159695	6.8%
6	133909	5.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	2338096	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	584524	25.0%
0	584524	25.0%
1	584524	25.0%
7	290920	12.4%
8	159695	6.8%
6	133909	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2338096	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	584524	25.0%
0	584524	25.0%
1	584524	25.0%
7	290920	12.4%
8	159695	6.8%
6	133909	5.7%

Month
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.1676544

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	4
median	7
Q3	11
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.4863048
Coefficient of variation (CV)	0.4863941
Kurtosis	-1.3726432
Mean	7.1676544
Median Absolute Deviation (MAD)	4
Skewness	-0.1929145
Sum	4189666
Variance	12.154321
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
11	155456	26.6%
5	62603	10.7%
3	61489	10.5%
8	48514	8.3%
7	39151	6.7%
2	38777	6.6%
6	34530	5.9%
4	34091	5.8%
10	30623	5.2%
12	29199	5.0%
Other values (2)	50091	8.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	26067	4.5%
2	38777	6.6%
3	61489	10.5%
4	34091	5.8%
5	62603	10.7%
6	34530	5.9%
7	39151	6.7%
8	48514	8.3%
9	24024	4.1%
10	30623	5.2%

Value	Count	Frequency (%)
12	29199	5.0%
11	155456	26.6%
10	30623	5.2%
9	24024	4.1%
8	48514	8.3%
7	39151	6.7%
6	34530	5.9%
5	62603	10.7%
4	34091	5.8%
3	61489	10.5%

Customer Since
Date

Distinct	26
Distinct (%)	< 0.1%
Missing	11
Missing (%)	< 0.1%
Memory size	4.5 MiB

Minimum	2016-07-01 00:00:00
Maximum	2018-08-01 00:00:00

Histogram

Histogram with fixed size bins (bins=26)

M-Y
Categorical

HIGH CORRELATION

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

Nov-17	83928
Nov-16	71528
Mar-18	41955
May-17	34736
May-18	27867
Other values (21)	324510

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	3507144
Distinct characters	27
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jul-16
2nd row	Jul-16
3rd row	Jul-16
4th row	Jul-16
5th row	Jul-16

Common Values

Value	Count	Frequency (%)
Nov-17	83928	14.4%
Nov-16	71528	12.2%
Mar-18	41955	7.2%
May-17	34736	5.9%
May-18	27867	4.8%
Feb-18	26916	4.6%
Aug-17	25083	4.3%
Apr-17	21678	3.7%
Jun-17	19793	3.4%
Mar-17	19534	3.3%
Other values (16)	211506	36.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nov-17	83928	14.4%
nov-16	71528	12.2%
mar-18	41955	7.2%
may-17	34736	5.9%
may-18	27867	4.8%
feb-18	26916	4.6%
aug-17	25083	4.3%
apr-17	21678	3.7%
jun-17	19793	3.4%
mar-17	19534	3.3%
Other values (16)	211506	36.2%

Most occurring characters

Value	Count	Frequency (%)
-	584524	16.7%
1	584524	16.7%
7	290920	8.3%
8	159695	4.6%
N	155456	4.4%
o	155456	4.4%
v	155456	4.4%
a	150159	4.3%
6	133909	3.8%
M	124092	3.5%
Other values (17)	1012953	28.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1169048	33.3%
Lowercase Letter	1169048	33.3%
Dash Punctuation	584524	16.7%
Uppercase Letter	584524	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	155456	13.3%
v	155456	13.3%
a	150159	12.8%
u	122195	10.5%
r	95580	8.2%
e	92000	7.9%
y	62603	5.4%
n	60597	5.2%
c	59822	5.1%
p	58115	5.0%
Other values (4)	157065	13.4%

Uppercase Letter

Value	Count	Frequency (%)
N	155456	26.6%
M	124092	21.2%
J	99748	17.1%
A	82605	14.1%
F	38777	6.6%
O	30623	5.2%
D	29199	5.0%
S	24024	4.1%

Decimal Number

Value	Count	Frequency (%)
1	584524	50.0%
7	290920	24.9%
8	159695	13.7%
6	133909	11.5%

Dash Punctuation

Value	Count	Frequency (%)
-	584524	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1753572	50.0%
Latin	1753572	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	155456	8.9%
o	155456	8.9%
v	155456	8.9%
a	150159	8.6%
M	124092	7.1%
u	122195	7.0%
J	99748	5.7%
r	95580	5.5%
e	92000	5.2%
A	82605	4.7%
Other values (12)	520825	29.7%

Common

Value	Count	Frequency (%)
-	584524	33.3%
1	584524	33.3%
7	290920	16.6%
8	159695	9.1%
6	133909	7.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3507144	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	584524	16.7%
1	584524	16.7%
7	290920	8.3%
8	159695	4.6%
N	155456	4.4%
o	155456	4.4%
v	155456	4.4%
a	150159	4.3%
6	133909	3.8%
M	124092	3.5%
Other values (17)	1012953	28.9%

FY
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

FY18	306883
FY17	254706
FY19	22935

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	2338096
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FY17
2nd row	FY17
3rd row	FY17
4th row	FY17
5th row	FY17

Common Values

Value	Count	Frequency (%)
FY18	306883	52.5%
FY17	254706	43.6%
FY19	22935	3.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fy18	306883	52.5%
fy17	254706	43.6%
fy19	22935	3.9%

Most occurring characters

Value	Count	Frequency (%)
F	584524	25.0%
Y	584524	25.0%
1	584524	25.0%
8	306883	13.1%
7	254706	10.9%
9	22935	1.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1169048	50.0%
Decimal Number	1169048	50.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	584524	50.0%
8	306883	26.3%
7	254706	21.8%
9	22935	2.0%

Uppercase Letter

Value	Count	Frequency (%)
F	584524	50.0%
Y	584524	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1169048	50.0%
Common	1169048	50.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	584524	50.0%
8	306883	26.3%
7	254706	21.8%
9	22935	2.0%

Latin

Value	Count	Frequency (%)
F	584524	50.0%
Y	584524	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2338096	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	584524	25.0%
Y	584524	25.0%
1	584524	25.0%
8	306883	13.1%
7	254706	10.9%
9	22935	1.0%

Customer ID
Real number (ℝ)

HIGH CORRELATION

Distinct	115326
Distinct (%)	19.7%
Missing	11
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	45790.512

Minimum	1
Maximum	115326
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	1
5-th percentile	548
Q1	13516
median	42856
Q3	73536
95-th percentile	107029
Maximum	115326
Range	115325
Interquartile range (IQR)	60020

Descriptive statistics

Standard deviation	34414.962
Coefficient of variation (CV)	0.75157409
Kurtosis	-1.1258359
Mean	45790.512
Median Absolute Deviation (MAD)	29897
Skewness	0.32626641
Sum	2.676515 × 10¹⁰
Variance	1.1843896 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85775	2524	0.4%
163	2349	0.4%
35	1877	0.3%
33	1397	0.2%
31025	1369	0.2%
806	1310	0.2%
1404	1269	0.2%
767	1234	0.2%
820	1190	0.2%
58	1182	0.2%
Other values (115316)	568812	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	< 0.1%
3	5	< 0.1%
4	428	0.1%
5	1	< 0.1%
6	2	< 0.1%
7	4	< 0.1%
8	2	< 0.1%
9	1	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
115326	1	< 0.1%
115325	2	< 0.1%
115324	1	< 0.1%
115323	1	< 0.1%
115322	2	< 0.1%
115321	1	< 0.1%
115320	3	< 0.1%
115319	3	< 0.1%
115318	1	< 0.1%
115317	1	< 0.1%

Auto

Heatmap
Table

	item_id	price	qty_ordered	grand_total	discount_amount	Month	Customer ID	status	category_name_1	payment_method	BI Status	Year	M-Y	FY
item_id	1.000	0.179	0.169	0.293	0.143	-0.275	0.767	0.153	0.194	0.289	0.213	0.927	0.891	0.778
price	0.179	1.000	-0.163	0.730	0.282	-0.057	0.221	0.028	0.045	0.070	0.039	0.052	0.054	0.067
qty_ordered	0.169	-0.163	1.000	0.058	-0.049	-0.158	0.126	0.001	0.005	0.006	0.002	0.003	0.011	0.002
grand_total	0.293	0.730	0.058	1.000	0.247	-0.113	0.277	0.000	0.004	0.012	0.001	0.003	0.016	0.003
discount_amount	0.143	0.282	-0.049	0.247	1.000	0.057	0.099	0.016	0.047	0.066	0.020	0.009	0.038	0.021
Month	-0.275	-0.057	-0.158	-0.113	0.057	1.000	-0.206	0.111	0.168	0.176	0.155	0.486	1.000	0.369
Customer ID	0.767	0.221	0.126	0.277	0.099	-0.206	1.000	0.105	0.209	0.222	0.154	0.673	0.559	0.574
status	0.153	0.028	0.001	0.000	0.016	0.111	0.105	1.000	0.083	0.154	0.816	0.225	0.131	0.216
category_name_1	0.194	0.045	0.005	0.004	0.047	0.168	0.209	0.083	1.000	0.135	0.160	0.272	0.184	0.199
payment_method	0.289	0.070	0.006	0.012	0.066	0.176	0.222	0.154	0.135	1.000	0.330	0.359	0.243	0.410
BI Status	0.213	0.039	0.002	0.001	0.020	0.155	0.154	0.816	0.160	0.330	1.000	0.180	0.224	0.167
Year	0.927	0.052	0.003	0.003	0.009	0.486	0.673	0.225	0.272	0.359	0.180	1.000	1.000	0.535
M-Y	0.891	0.054	0.011	0.016	0.038	1.000	0.559	0.131	0.184	0.243	0.224	1.000	1.000	1.000
FY	0.778	0.067	0.002	0.003	0.021	0.369	0.574	0.216	0.199	0.410	0.167	0.535	1.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	item_id	status	created_at	sku	price	qty_ordered	grand_total	increment_id	category_name_1	sales_commission_code	discount_amount	payment_method	Working Date	BI Status	MV	Year	Month	Customer Since	M-Y	FY	Customer ID
0	211131	complete	2016-07-01	kreations_YI 06-L	1950.0	1	1950.0	100147443	Women's Fashion	\N	0.0	cod	07-01-16	#REF!	1,950	2016	7	2016-07-01	Jul-16	FY17	1.0
1	211133	canceled	2016-07-01	kcc_Buy 2 Frey Air Freshener & Get 1 Kasual Body Spray Free	240.0	1	240.0	100147444	Beauty & Grooming	\N	0.0	cod	07-01-16	Gross	240	2016	7	2016-07-01	Jul-16	FY17	2.0
2	211134	canceled	2016-07-01	Ego_UP0017-999-MR0	2450.0	1	2450.0	100147445	Women's Fashion	\N	0.0	cod	07-01-16	Gross	2,450	2016	7	2016-07-01	Jul-16	FY17	3.0
3	211135	complete	2016-07-01	kcc_krone deal	360.0	1	60.0	100147446	Beauty & Grooming	R-FSD-52352	300.0	cod	07-01-16	Net	360	2016	7	2016-07-01	Jul-16	FY17	4.0
4	211136	order_refunded	2016-07-01	BK7010400AG	555.0	2	1110.0	100147447	Soghaat	\N	0.0	cod	07-01-16	Valid	1,110	2016	7	2016-07-01	Jul-16	FY17	5.0
5	211137	canceled	2016-07-01	UK_Namkino All In One 200 Gms	80.0	1	80.0	100147448	Soghaat	\N	0.0	cod	07-01-16	Gross	80	2016	7	2016-07-01	Jul-16	FY17	6.0
6	211138	complete	2016-07-01	kcc_krone deal	360.0	1	60.0	100147449	Beauty & Grooming	\N	300.0	cod	07-01-16	Net	360	2016	7	2016-07-01	Jul-16	FY17	7.0
7	211139	complete	2016-07-01	UK_Namkino Mix Nimco 400 Gms	170.0	1	170.0	100147450	Soghaat	\N	0.0	cod	07-01-16	Net	170	2016	7	2016-07-01	Jul-16	FY17	6.0
8	211140	canceled	2016-07-01	Apple iPhone 6S 64GB	96499.0	1	96499.0	100147451	Mobiles & Tablets	\N	0.0	ublcreditcard	07-01-16	Gross	96,499	2016	7	2016-07-01	Jul-16	FY17	8.0
9	211141	canceled	2016-07-01	Apple iPhone 6S 64GB	96499.0	1	96499.0	100147452	Mobiles & Tablets	\N	0.0	mygateway	07-01-16	Gross	96,499	2016	7	2016-07-01	Jul-16	FY17	8.0

	item_id	status	created_at	sku	price	qty_ordered	grand_total	increment_id	category_name_1	sales_commission_code	payment_method	Working Date	BI Status	MV	Year	Month	Customer Since	M-Y	FY	Customer ID
584514	905196	paid	2018-08-28	MEFGUL5A9F882AA5B99-36	1299.0	1	0.0	100562381	Men's Fashion	NaN	customercredit	8/28/2018	Valid	1,299	2018	8	2018-06-01	Aug-18	FY19	111132.0
584515	905198	paid	2018-08-28	MEFPAK5B360B03C6B72	999.0	1	0.0	100562381	Men's Fashion	NaN	customercredit	8/28/2018	Valid	999	2018	8	2018-06-01	Aug-18	FY19	111132.0
584516	905199	pending	2018-08-28	MATINF59BAB39FDBEF1	6760.0	2	13770.0	100562382	Mobiles & Tablets	NaN	jazzvoucher	8/28/2018	Gross	13,520	2018	8	2016-09-01	Aug-18	FY19	8123.0
584517	905200	cod	2018-08-28	WOFVAL59D5EA84167F9-M	400.0	1	550.0	100562383	Women's Fashion	NaN	cod	8/28/2018	Valid	400	2018	8	2018-08-01	Aug-18	FY19	115325.0
584518	905202	cod	2018-08-28	WOFNIG5B4D7EB0E9FDD-L	499.0	1	649.0	100562384	Women's Fashion	NaN	cod	8/28/2018	Valid	499	2018	8	2018-08-01	Aug-18	FY19	115325.0
584519	905204	cod	2018-08-28	WOFSCE5AE00357AECDE	699.0	1	849.0	100562385	Women's Fashion	NaN	cod	8/28/2018	Valid	699	2018	8	2018-08-01	Aug-18	FY19	115320.0
584520	905205	processing	2018-08-28	MATHUA5AF70A7D1E50A	35599.0	1	35899.0	100562386	Mobiles & Tablets	NaN	bankalfalah	8/28/2018	Gross	35,599	2018	8	2018-08-01	Aug-18	FY19	115326.0
584521	905206	processing	2018-08-28	MATSAM5B6D7208C6D30	129999.0	2	652178.0	100562387	Mobiles & Tablets	NaN	bankalfalah	8/28/2018	Gross	259,998	2018	8	2018-07-01	Aug-18	FY19	113474.0
584522	905207	processing	2018-08-28	MATSAM5B1509B4696EA	87300.0	2	652178.0	100562387	Mobiles & Tablets	NaN	bankalfalah	8/28/2018	Gross	174,600	2018	8	2018-07-01	Aug-18	FY19	113474.0
584523	905208	processing	2018-08-28	MATSAM5B10F91A9B6AB	108640.0	2	652178.0	100562387	Mobiles & Tablets	NaN	bankalfalah	8/28/2018	Gross	217,280	2018	8	2018-07-01	Aug-18	FY19	113474.0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Other Punctuation

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Math Symbol

Control

Dash Punctuation

Space Separator

Open Punctuation

Close Punctuation

Other Symbol

Connector Punctuation

Currency Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Math Symbol

Dash Punctuation

Space Separator

Connector Punctuation

Format

Open Punctuation

Modifier Symbol

Control

Other Symbol

Nonspacing Mark

Most occurring scripts

Most frequent character per script

Latin

Common